Oracle

Configuration Adaptions

The needed SQL scripts for the database creation can be found in the installation package:
...\database_scripts\scripts\Oracle_Other\system

1. Start your utility program to have access to your Oracle database.

2. Log in as user SYSTEM (sysdba).

3. Open the script V00_sys_tablespace.sql and change the paths to your local system.

4. Run the script.

5. Open the script V01_sys_create_schema.sql.

   :::info Important:
   The password of the SOLUTIONHUB database user should be changed for security reasons!
   :::

6. Run the script.

7. Disconnect.

8. Set up the database by following the steps described in Flyway database setup.

---

The created user in step 5 is created with the default profile, which has a limited password lifetime in Oracle Version 10 and 11. If this is unwanted for the Orchestra runtime user, run the following statements as admin:

CREATE PROFILE ORC_PROFILE LIMIT
  FAILED_LOGIN_ATTEMPTS UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED;

ALTER USER <Orchestra-Runtime-User>
  PROFILE ORC_PROFILE;